package kr.hkit.androidcomplete03.ch26;

public class ProductFrameWork {
	public static final String DB_NAME = "product";

	public static final int DB_VERSION = 1;

	public static final String CREATE_TBL = "create table product ( _id INTEGER PRIMARY KEY AUTOINCREMENT, "
			+ "name TEXT, price INTEGER);";

	public static final String[] INSERT_DATA = { 
		"insert into product values (null, '오징어땅콩', 900)",
		"insert into product values (null, '수미감자', 2000)",
		"insert into product values (null, '겨울왕국엘사', 20000)",
		"insert into product values (null, '안드로이드 프로그래밍 완전정복', 35000)",
		"insert into product values (null, 'KFC치킨 응원버켓', 13000)",
		"insert into product values (null, '정보처리기사실기 응시료', 22700)",
		"insert into product values (null, '똥집의달인(간장똥집)', 12000)"
		};
	
	public static final String DROP_TBL = "drop table if exists product;";
}
